package com.itheima.device.dao;

import com.itheima.device.pojo.DeviceInfo;
import org.apache.ibatis.annotations.Delete;
import org.apache.ibatis.annotations.Select;
import tk.mybatis.mapper.common.Mapper;

import java.util.List;

public interface DeviceInfoMapper extends Mapper<DeviceInfo> {
    //根据设备Id查询设备说明
    @Select("select * from t_device_info where did = #{id}")
    List<DeviceInfo> findDeviceInfoByDid(Integer id);
    //根据设备id删除设备与设备说明书信息
    @Delete("delete * from t_device_info where did = #{did}")
     DeviceInfo deleteDeviceInfoByDid(Integer did);

}
